--
    drop table SK_SERIAL cascade constraints;
    
    create table SK_SERIAL (
        SERIAL INTEGER not null,
        PROVINCE_ID VARCHAR2(255) not null
    );



    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (1, 0, 'console', '首页', 'action', '/console/index.do', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);
    
    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (3, 0, 'recruitSite', '招商网站', 'page', '/site/index.jsp', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);
--user
    
--    insert 
--    into
--        SK_USER
--        (LOGIN_NAME, LOGIN_PASSWORD, OTHER_NAME, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ('testadmin', '111111', '经销商招募管理员', '1', 0, sysdate, null, null, SEQ_SK_USER.nextval);	
--    
--    insert 
--    into
--        SK_USER
--        (LOGIN_NAME, LOGIN_PASSWORD, OTHER_NAME, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ('testmanager', '111111', '经销商招募网络专员', '1', 0, sysdate, null, null, SEQ_SK_USER.nextval);	
--    
--    insert 
--    into
--        SK_USER
--        (LOGIN_NAME, LOGIN_PASSWORD, OTHER_NAME, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ('testread', '111111', '经销商招募查看用户', '1', 0, sysdate, null, null, SEQ_SK_USER.nextval);	

--role    
    insert 
    into
        SK_ROLE
        (ROLE_NAME, TITLE, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ('role_console_user', '后台用户', '1', 0, sysdate, null, null, SEQ_SK_ROLE.nextval);
    
    insert 
    into
        SK_ROLE
        (ROLE_NAME, TITLE, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ('role_user', '注册用户', '1', 0, sysdate, null, null, SEQ_SK_ROLE.nextval);

    insert 
    into
        SK_ROLE
        (ROLE_NAME, TITLE, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ('role_recruit_admin', '经销商招募-管理员', '1', 0, sysdate, null, null, SEQ_SK_ROLE.nextval);	
    
    insert 
    into
        SK_ROLE
        (ROLE_NAME, TITLE, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ('role_recruit_region_manager', '经销商招募-网络专员', '1', 0, sysdate, null, null, SEQ_SK_ROLE.nextval);	
    
    insert 
    into
        SK_ROLE
        (ROLE_NAME, TITLE, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ('role_recruit_read', '经销商招募-查询用户', '1', 0, sysdate, null, null, SEQ_SK_ROLE.nextval);	
     
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_console_user'), (select ID from SK_MENU where MENU_NAME = 'console'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
--user role rel
    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_user'), (select ID from SK_USER where LOGIN_NAME = 'testadmin'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_console_user'), (select ID from SK_USER where LOGIN_NAME = 'testadmin'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_USER where LOGIN_NAME = 'testadmin'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_user'), (select ID from SK_USER where LOGIN_NAME = 'testmanager'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_console_user'), (select ID from SK_USER where LOGIN_NAME = 'testmanager'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_USER where LOGIN_NAME = 'testmanager'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_user'), (select ID from SK_USER where LOGIN_NAME = 'testread'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_console_user'), (select ID from SK_USER where LOGIN_NAME = 'testread'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);
--    
--    insert 
--    into
--        SK_USER_ROLE_REL
--        (ROLE_ID, USER_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
--    values
--        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_USER where LOGIN_NAME = 'testread'), '1', 0, sysdate, null, null, SEQ_SK_USER_ROLE_REL.nextval);

--resource
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_user', '注册用户权限', '/site/user/*.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_index', '后台首页权限', '/console/index.do', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_jsp', '', '/console/**/*.jsp*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_index', '', '/console/recruit/index.do', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyBaseEx_view', '', '/console/recruit/applyBaseEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyBaseEx_list', '', '/console/recruit/applyBaseEx.do?method=list*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyConfirmEx_view', '', '/console/recruit/applyConfirmEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyDivideEx_view', '', '/console/recruit/applyDivideEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_sknAuditEx_view', '', '/console/recruit/sknAuditEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_finalJudgmentEx_view', '', '/console/recruit/finalJudgmentEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_firstTrialEx_view', '', '/console/recruit/firstTrialEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_visitEx_view', '', '/console/recruit/visitEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_matReviewEx_view', '', '/console/recruit/matReviewEx.do?method=view*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyProcessReport', '', '/console/recruit/applyProcessReport.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyRegionReport', '', '/console/recruit/applyRegionReport.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyPlanReport', '', '/console/recruit/applyPlanReport.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_townEx', '', '/console/recruit/townEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);

insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_firstTrialEx', '', '/console/recruit/firstTrialEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_visitEx', '', '/console/recruit/visitEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_matReviewEx', '', '/console/recruit/matReviewEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);

insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_index_system', '', '/console/index.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyBaseEx', '', '/console/recruit/applyBaseEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyConfirmEx', '', '/console/recruit/applyConfirmEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_applyDivideEx', '', '/console/recruit/applyDivideEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_sknAuditEx', '', '/console/recruit/sknAuditEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_finalJudgmentEx', '', '/console/recruit/finalJudgmentEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_recruitUserEx', '', '/console/recruit/recruitUserEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);
insert into SK_RESOURCE (RESOURCE_NAME, TITLE, RESOURCE_STRING, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ('res_console_recruit_rmProvinceEx', '', '/console/recruit/rmProvinceEx.do*', '1', 0, sysdate, null, null, SEQ_SK_RESOURCE.nextval);


--resource role rel
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_user'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_user'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);

insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_console_user'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_index'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_console_user'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_jsp'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);

insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_index'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_jsp'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_index'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyBaseEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyBaseEx_list'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyConfirmEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyDivideEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_sknAuditEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_finalJudgmentEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_firstTrialEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_visitEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_matReviewEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyProcessReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyRegionReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_townEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);

insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_index'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_jsp'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_index'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyBaseEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyBaseEx_list'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyConfirmEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyDivideEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_sknAuditEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_finalJudgmentEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_firstTrialEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_visitEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_matReviewEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyProcessReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyRegionReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_townEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyConfirmEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_firstTrialEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_visitEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_matReviewEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);

insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_index'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_jsp'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_index'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyBaseEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyBaseEx_list'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyConfirmEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyDivideEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_sknAuditEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_finalJudgmentEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_firstTrialEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_visitEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_matReviewEx_view'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyProcessReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyRegionReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_townEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_index_system'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyBaseEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_applyDivideEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_sknAuditEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_finalJudgmentEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_recruitUserEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);
insert into SK_RES_ROLE_REL (ROLE_ID, RESOURCE_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) values ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_RESOURCE where RESOURCE_NAME = 'res_console_recruit_rmProvinceEx'), '1', 0, sysdate, null, null, SEQ_SK_RES_ROLE_REL.nextval);

	--ALTER SEQUENCE SEQ_SK_DICTIONARY RESTART WITH (SELECT max(id) + 1 FROM SK_DICTIONARY);

    insert 
    into
        SK_DICTIONARY
        (SERIAL, PARENT_CODE, TYPE_CODE, CODE, TITLE,STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (0, 'root', 'root', 'root', '字典分类', '1', 0, sysdate, null, null, SEQ_SK_DICTIONARY.nextval);

    insert 
    into
        SK_DICTIONARY
        (SERIAL, PARENT_CODE, TYPE_CODE, CODE, TITLE,STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (0, 'root', 'root', 'yesOrNo', '是否', '1', 0, sysdate, null, null, SEQ_SK_DICTIONARY.nextval);

    insert 
    into
        SK_DICTIONARY
        (SERIAL, PARENT_CODE, TYPE_CODE, CODE, TITLE,STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (0, 'root', 'root', 'gender', '性别', '1', 0, sysdate, null, null, SEQ_SK_DICTIONARY.nextval);
 
    insert 
    into
        SK_DICTIONARY
        (SERIAL, PARENT_CODE, TYPE_CODE, CODE, TITLE,STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (0, 'root', 'yesOrNo', '1', '是', '1', 0, sysdate, null, null, SEQ_SK_DICTIONARY.nextval);

    insert 
    into
        SK_DICTIONARY
        (SERIAL, PARENT_CODE, TYPE_CODE, CODE, TITLE,STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (0, 'root', 'yesOrNo', '0', '否', '1', 0, sysdate, null, null, SEQ_SK_DICTIONARY.nextval);

    insert 
    into
        SK_DICTIONARY
        (SERIAL, PARENT_CODE, TYPE_CODE, CODE, TITLE,STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (0, 'root', 'gender', '1', '男', '1', 0, sysdate, null, null, SEQ_SK_DICTIONARY.nextval);

    insert 
    into
        SK_DICTIONARY
        (SERIAL, PARENT_CODE, TYPE_CODE, CODE, TITLE,STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (0, 'root', 'gender', '2', '女', '1', 0, sysdate, null, null, SEQ_SK_DICTIONARY.nextval);


---

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (2, 0, 'recruit', '经销商招募', 'action', '/console/recruit/index.do', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (1, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyConfirm', '申请审批', 'action', '/console/recruit/sknAuditEx.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (1, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'firstTrial', '申请审批', 'action', '/console/recruit/applyConfirmEx.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (2, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyBase', '申请信息查询', 'action', '/console/recruit/applyBaseEx.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (3, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyProcessReport', '进度统计报表', 'action', '/console/recruit/applyProcessReport.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (4, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyRegionReport', '区域统计报表', 'action', '/console/recruit/applyRegionReport.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (5, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyPlanReport', '规划统计报表', 'action', '/console/recruit/applyPlanReport.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (6, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'town', '热点加盟城市', 'action', '/console/recruit/townEx.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (7, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'recruitUser', '权限管理', 'action', '/console/recruit/recruitUserEx.do?method=list', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (8, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyCondition', '申请条件', 'page', '/console/recruit/conditions.jsp', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);

    insert 
    into
        SK_MENU
        (SERIAL, PARENT_ID, MENU_NAME, TITLE, MENU_TYPE, MENU_URL, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        (9, (select ID from SK_MENU where MENU_NAME = 'recruit'), 'applyFlow', '申请流程', 'page', '/console/recruit/flow.jsp', '1', 0, sysdate, null, null, SEQ_SK_MENU.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'recruit'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'recruit'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'recruit'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'recruitSite'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'recruitSite'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'recruitSite'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'town'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'town'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'town'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyCondition'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'applyCondition'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'applyCondition'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyFlow'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'applyFlow'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'applyFlow'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'recruitUser'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
	
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyConfirm'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
	
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'firstTrial'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyBase'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'applyBase'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'applyBase'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyProcessReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'applyProcessReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'applyProcessReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyProcessReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_admin'), (select ID from SK_MENU where MENU_NAME = 'applyPlanReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_region_manager'), (select ID from SK_MENU where MENU_NAME = 'applyRegionReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);
    
    insert 
    into
        SK_MENU_ROLE_REL
        (ROLE_ID, MENU_ID, STATUS, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE, ID) 
    values
        ((select ID from SK_ROLE where ROLE_NAME = 'role_recruit_read'), (select ID from SK_MENU where MENU_NAME = 'applyRegionReport'), '1', 0, sysdate, null, null, SEQ_SK_MENU_ROLE_REL.nextval);

	
commit;